{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from dfs0 import dfs0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " The output data is `pandas DataFrame`, and the column of `Time` format is Datetime.  \n",
    " This demo data is the MIKE pile scour tool outputs."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>Scour Depth</th>\n",
       "      <th>Direction of Max. Scour Width [d</th>\n",
       "      <th>Maximum Scour Width</th>\n",
       "      <th>Scour Width 90 degrees clockwise</th>\n",
       "      <th>Scour Width 180 degrees clockwis</th>\n",
       "      <th>Scour Width 270 degrees clockwis</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017-01-01 02:00:00</td>\n",
       "      <td>0.034506</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.094804</td>\n",
       "      <td>0.073998</td>\n",
       "      <td>0.059766</td>\n",
       "      <td>0.073998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017-01-01 03:00:00</td>\n",
       "      <td>0.066143</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.181727</td>\n",
       "      <td>0.141845</td>\n",
       "      <td>0.114564</td>\n",
       "      <td>0.141845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017-01-01 04:00:00</td>\n",
       "      <td>0.095151</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.261426</td>\n",
       "      <td>0.204053</td>\n",
       "      <td>0.164807</td>\n",
       "      <td>0.204053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017-01-01 05:00:00</td>\n",
       "      <td>0.121748</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.334500</td>\n",
       "      <td>0.261090</td>\n",
       "      <td>0.210874</td>\n",
       "      <td>0.261090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017-01-01 06:00:00</td>\n",
       "      <td>0.146134</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.401501</td>\n",
       "      <td>0.313386</td>\n",
       "      <td>0.253112</td>\n",
       "      <td>0.313386</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017-01-01 07:00:00</td>\n",
       "      <td>0.168494</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.462932</td>\n",
       "      <td>0.361336</td>\n",
       "      <td>0.291839</td>\n",
       "      <td>0.361336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017-01-01 08:00:00</td>\n",
       "      <td>0.188994</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.519258</td>\n",
       "      <td>0.405300</td>\n",
       "      <td>0.327348</td>\n",
       "      <td>0.405300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017-01-01 09:00:00</td>\n",
       "      <td>0.207791</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.570901</td>\n",
       "      <td>0.445609</td>\n",
       "      <td>0.359905</td>\n",
       "      <td>0.445609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017-01-01 10:00:00</td>\n",
       "      <td>0.225025</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.618252</td>\n",
       "      <td>0.482569</td>\n",
       "      <td>0.389756</td>\n",
       "      <td>0.482569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017-01-01 11:00:00</td>\n",
       "      <td>0.240827</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.661668</td>\n",
       "      <td>0.516456</td>\n",
       "      <td>0.417125</td>\n",
       "      <td>0.516456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017-01-01 12:00:00</td>\n",
       "      <td>0.255316</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.701474</td>\n",
       "      <td>0.547527</td>\n",
       "      <td>0.442220</td>\n",
       "      <td>0.547527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017-01-01 13:00:00</td>\n",
       "      <td>0.268600</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.737972</td>\n",
       "      <td>0.576015</td>\n",
       "      <td>0.465229</td>\n",
       "      <td>0.576015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017-01-01 14:00:00</td>\n",
       "      <td>0.280780</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.771437</td>\n",
       "      <td>0.602135</td>\n",
       "      <td>0.486325</td>\n",
       "      <td>0.602135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017-01-01 15:00:00</td>\n",
       "      <td>0.291948</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.802120</td>\n",
       "      <td>0.626084</td>\n",
       "      <td>0.505668</td>\n",
       "      <td>0.626084</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017-01-01 16:00:00</td>\n",
       "      <td>0.302187</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.830252</td>\n",
       "      <td>0.648042</td>\n",
       "      <td>0.523403</td>\n",
       "      <td>0.648042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017-01-01 17:00:00</td>\n",
       "      <td>0.311575</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.856046</td>\n",
       "      <td>0.668176</td>\n",
       "      <td>0.539665</td>\n",
       "      <td>0.668176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017-01-01 18:00:00</td>\n",
       "      <td>0.320183</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.879697</td>\n",
       "      <td>0.686636</td>\n",
       "      <td>0.554574</td>\n",
       "      <td>0.686636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017-01-01 19:00:00</td>\n",
       "      <td>0.328076</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.901381</td>\n",
       "      <td>0.703561</td>\n",
       "      <td>0.568244</td>\n",
       "      <td>0.703561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017-01-01 20:00:00</td>\n",
       "      <td>0.335312</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.921263</td>\n",
       "      <td>0.719080</td>\n",
       "      <td>0.580778</td>\n",
       "      <td>0.719080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017-01-01 21:00:00</td>\n",
       "      <td>0.341947</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.939493</td>\n",
       "      <td>0.733309</td>\n",
       "      <td>0.592270</td>\n",
       "      <td>0.733309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017-01-01 22:00:00</td>\n",
       "      <td>0.348031</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.956207</td>\n",
       "      <td>0.746355</td>\n",
       "      <td>0.602807</td>\n",
       "      <td>0.746355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017-01-01 23:00:00</td>\n",
       "      <td>0.353609</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.971532</td>\n",
       "      <td>0.758316</td>\n",
       "      <td>0.612468</td>\n",
       "      <td>0.758316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017-01-02 00:00:00</td>\n",
       "      <td>0.358723</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.985583</td>\n",
       "      <td>0.769284</td>\n",
       "      <td>0.621326</td>\n",
       "      <td>0.769284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017-01-02 01:00:00</td>\n",
       "      <td>0.363412</td>\n",
       "      <td>180.0</td>\n",
       "      <td>0.998466</td>\n",
       "      <td>0.779340</td>\n",
       "      <td>0.629448</td>\n",
       "      <td>0.779340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017-01-02 02:00:00</td>\n",
       "      <td>0.367711</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.010279</td>\n",
       "      <td>0.788560</td>\n",
       "      <td>0.636895</td>\n",
       "      <td>0.788560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017-01-02 03:00:00</td>\n",
       "      <td>0.371653</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.021110</td>\n",
       "      <td>0.797014</td>\n",
       "      <td>0.643723</td>\n",
       "      <td>0.797014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017-01-02 04:00:00</td>\n",
       "      <td>0.375268</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.031040</td>\n",
       "      <td>0.804765</td>\n",
       "      <td>0.649983</td>\n",
       "      <td>0.804765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017-01-02 05:00:00</td>\n",
       "      <td>0.378582</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.040145</td>\n",
       "      <td>0.811871</td>\n",
       "      <td>0.655723</td>\n",
       "      <td>0.811871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017-01-02 06:00:00</td>\n",
       "      <td>0.381620</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.048493</td>\n",
       "      <td>0.818387</td>\n",
       "      <td>0.660986</td>\n",
       "      <td>0.818387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017-01-02 07:00:00</td>\n",
       "      <td>0.384406</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.056147</td>\n",
       "      <td>0.824362</td>\n",
       "      <td>0.665811</td>\n",
       "      <td>0.824362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2129</th>\n",
       "      <td>2017-03-30 19:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2130</th>\n",
       "      <td>2017-03-30 20:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2131</th>\n",
       "      <td>2017-03-30 21:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2132</th>\n",
       "      <td>2017-03-30 22:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2133</th>\n",
       "      <td>2017-03-30 23:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2134</th>\n",
       "      <td>2017-03-31 00:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2135</th>\n",
       "      <td>2017-03-31 01:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2136</th>\n",
       "      <td>2017-03-31 02:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2137</th>\n",
       "      <td>2017-03-31 03:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2138</th>\n",
       "      <td>2017-03-31 04:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2139</th>\n",
       "      <td>2017-03-31 05:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2140</th>\n",
       "      <td>2017-03-31 06:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2141</th>\n",
       "      <td>2017-03-31 07:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2142</th>\n",
       "      <td>2017-03-31 08:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2143</th>\n",
       "      <td>2017-03-31 09:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2144</th>\n",
       "      <td>2017-03-31 10:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2145</th>\n",
       "      <td>2017-03-31 11:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2146</th>\n",
       "      <td>2017-03-31 12:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2147</th>\n",
       "      <td>2017-03-31 13:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2148</th>\n",
       "      <td>2017-03-31 14:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2149</th>\n",
       "      <td>2017-03-31 15:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2150</th>\n",
       "      <td>2017-03-31 16:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2151</th>\n",
       "      <td>2017-03-31 17:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2152</th>\n",
       "      <td>2017-03-31 18:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2153</th>\n",
       "      <td>2017-03-31 19:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2154</th>\n",
       "      <td>2017-03-31 20:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2155</th>\n",
       "      <td>2017-03-31 21:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2156</th>\n",
       "      <td>2017-03-31 22:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2157</th>\n",
       "      <td>2017-03-31 23:00:00</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2158</th>\n",
       "      <td>NaT</td>\n",
       "      <td>0.415138</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1.140582</td>\n",
       "      <td>0.890266</td>\n",
       "      <td>0.719040</td>\n",
       "      <td>0.890266</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2159 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Time  Scour Depth  Direction of Max. Scour Width [d  \\\n",
       "0    2017-01-01 02:00:00     0.034506                             180.0   \n",
       "1    2017-01-01 03:00:00     0.066143                             180.0   \n",
       "2    2017-01-01 04:00:00     0.095151                             180.0   \n",
       "3    2017-01-01 05:00:00     0.121748                             180.0   \n",
       "4    2017-01-01 06:00:00     0.146134                             180.0   \n",
       "5    2017-01-01 07:00:00     0.168494                             180.0   \n",
       "6    2017-01-01 08:00:00     0.188994                             180.0   \n",
       "7    2017-01-01 09:00:00     0.207791                             180.0   \n",
       "8    2017-01-01 10:00:00     0.225025                             180.0   \n",
       "9    2017-01-01 11:00:00     0.240827                             180.0   \n",
       "10   2017-01-01 12:00:00     0.255316                             180.0   \n",
       "11   2017-01-01 13:00:00     0.268600                             180.0   \n",
       "12   2017-01-01 14:00:00     0.280780                             180.0   \n",
       "13   2017-01-01 15:00:00     0.291948                             180.0   \n",
       "14   2017-01-01 16:00:00     0.302187                             180.0   \n",
       "15   2017-01-01 17:00:00     0.311575                             180.0   \n",
       "16   2017-01-01 18:00:00     0.320183                             180.0   \n",
       "17   2017-01-01 19:00:00     0.328076                             180.0   \n",
       "18   2017-01-01 20:00:00     0.335312                             180.0   \n",
       "19   2017-01-01 21:00:00     0.341947                             180.0   \n",
       "20   2017-01-01 22:00:00     0.348031                             180.0   \n",
       "21   2017-01-01 23:00:00     0.353609                             180.0   \n",
       "22   2017-01-02 00:00:00     0.358723                             180.0   \n",
       "23   2017-01-02 01:00:00     0.363412                             180.0   \n",
       "24   2017-01-02 02:00:00     0.367711                             180.0   \n",
       "25   2017-01-02 03:00:00     0.371653                             180.0   \n",
       "26   2017-01-02 04:00:00     0.375268                             180.0   \n",
       "27   2017-01-02 05:00:00     0.378582                             180.0   \n",
       "28   2017-01-02 06:00:00     0.381620                             180.0   \n",
       "29   2017-01-02 07:00:00     0.384406                             180.0   \n",
       "...                  ...          ...                               ...   \n",
       "2129 2017-03-30 19:00:00     0.415138                             180.0   \n",
       "2130 2017-03-30 20:00:00     0.415138                             180.0   \n",
       "2131 2017-03-30 21:00:00     0.415138                             180.0   \n",
       "2132 2017-03-30 22:00:00     0.415138                             180.0   \n",
       "2133 2017-03-30 23:00:00     0.415138                             180.0   \n",
       "2134 2017-03-31 00:00:00     0.415138                             180.0   \n",
       "2135 2017-03-31 01:00:00     0.415138                             180.0   \n",
       "2136 2017-03-31 02:00:00     0.415138                             180.0   \n",
       "2137 2017-03-31 03:00:00     0.415138                             180.0   \n",
       "2138 2017-03-31 04:00:00     0.415138                             180.0   \n",
       "2139 2017-03-31 05:00:00     0.415138                             180.0   \n",
       "2140 2017-03-31 06:00:00     0.415138                             180.0   \n",
       "2141 2017-03-31 07:00:00     0.415138                             180.0   \n",
       "2142 2017-03-31 08:00:00     0.415138                             180.0   \n",
       "2143 2017-03-31 09:00:00     0.415138                             180.0   \n",
       "2144 2017-03-31 10:00:00     0.415138                             180.0   \n",
       "2145 2017-03-31 11:00:00     0.415138                             180.0   \n",
       "2146 2017-03-31 12:00:00     0.415138                             180.0   \n",
       "2147 2017-03-31 13:00:00     0.415138                             180.0   \n",
       "2148 2017-03-31 14:00:00     0.415138                             180.0   \n",
       "2149 2017-03-31 15:00:00     0.415138                             180.0   \n",
       "2150 2017-03-31 16:00:00     0.415138                             180.0   \n",
       "2151 2017-03-31 17:00:00     0.415138                             180.0   \n",
       "2152 2017-03-31 18:00:00     0.415138                             180.0   \n",
       "2153 2017-03-31 19:00:00     0.415138                             180.0   \n",
       "2154 2017-03-31 20:00:00     0.415138                             180.0   \n",
       "2155 2017-03-31 21:00:00     0.415138                             180.0   \n",
       "2156 2017-03-31 22:00:00     0.415138                             180.0   \n",
       "2157 2017-03-31 23:00:00     0.415138                             180.0   \n",
       "2158                 NaT     0.415138                             180.0   \n",
       "\n",
       "      Maximum Scour Width  Scour Width 90 degrees clockwise  \\\n",
       "0                0.094804                          0.073998   \n",
       "1                0.181727                          0.141845   \n",
       "2                0.261426                          0.204053   \n",
       "3                0.334500                          0.261090   \n",
       "4                0.401501                          0.313386   \n",
       "5                0.462932                          0.361336   \n",
       "6                0.519258                          0.405300   \n",
       "7                0.570901                          0.445609   \n",
       "8                0.618252                          0.482569   \n",
       "9                0.661668                          0.516456   \n",
       "10               0.701474                          0.547527   \n",
       "11               0.737972                          0.576015   \n",
       "12               0.771437                          0.602135   \n",
       "13               0.802120                          0.626084   \n",
       "14               0.830252                          0.648042   \n",
       "15               0.856046                          0.668176   \n",
       "16               0.879697                          0.686636   \n",
       "17               0.901381                          0.703561   \n",
       "18               0.921263                          0.719080   \n",
       "19               0.939493                          0.733309   \n",
       "20               0.956207                          0.746355   \n",
       "21               0.971532                          0.758316   \n",
       "22               0.985583                          0.769284   \n",
       "23               0.998466                          0.779340   \n",
       "24               1.010279                          0.788560   \n",
       "25               1.021110                          0.797014   \n",
       "26               1.031040                          0.804765   \n",
       "27               1.040145                          0.811871   \n",
       "28               1.048493                          0.818387   \n",
       "29               1.056147                          0.824362   \n",
       "...                   ...                               ...   \n",
       "2129             1.140582                          0.890266   \n",
       "2130             1.140582                          0.890266   \n",
       "2131             1.140582                          0.890266   \n",
       "2132             1.140582                          0.890266   \n",
       "2133             1.140582                          0.890266   \n",
       "2134             1.140582                          0.890266   \n",
       "2135             1.140582                          0.890266   \n",
       "2136             1.140582                          0.890266   \n",
       "2137             1.140582                          0.890266   \n",
       "2138             1.140582                          0.890266   \n",
       "2139             1.140582                          0.890266   \n",
       "2140             1.140582                          0.890266   \n",
       "2141             1.140582                          0.890266   \n",
       "2142             1.140582                          0.890266   \n",
       "2143             1.140582                          0.890266   \n",
       "2144             1.140582                          0.890266   \n",
       "2145             1.140582                          0.890266   \n",
       "2146             1.140582                          0.890266   \n",
       "2147             1.140582                          0.890266   \n",
       "2148             1.140582                          0.890266   \n",
       "2149             1.140582                          0.890266   \n",
       "2150             1.140582                          0.890266   \n",
       "2151             1.140582                          0.890266   \n",
       "2152             1.140582                          0.890266   \n",
       "2153             1.140582                          0.890266   \n",
       "2154             1.140582                          0.890266   \n",
       "2155             1.140582                          0.890266   \n",
       "2156             1.140582                          0.890266   \n",
       "2157             1.140582                          0.890266   \n",
       "2158             1.140582                          0.890266   \n",
       "\n",
       "      Scour Width 180 degrees clockwis  Scour Width 270 degrees clockwis  \n",
       "0                             0.059766                          0.073998  \n",
       "1                             0.114564                          0.141845  \n",
       "2                             0.164807                          0.204053  \n",
       "3                             0.210874                          0.261090  \n",
       "4                             0.253112                          0.313386  \n",
       "5                             0.291839                          0.361336  \n",
       "6                             0.327348                          0.405300  \n",
       "7                             0.359905                          0.445609  \n",
       "8                             0.389756                          0.482569  \n",
       "9                             0.417125                          0.516456  \n",
       "10                            0.442220                          0.547527  \n",
       "11                            0.465229                          0.576015  \n",
       "12                            0.486325                          0.602135  \n",
       "13                            0.505668                          0.626084  \n",
       "14                            0.523403                          0.648042  \n",
       "15                            0.539665                          0.668176  \n",
       "16                            0.554574                          0.686636  \n",
       "17                            0.568244                          0.703561  \n",
       "18                            0.580778                          0.719080  \n",
       "19                            0.592270                          0.733309  \n",
       "20                            0.602807                          0.746355  \n",
       "21                            0.612468                          0.758316  \n",
       "22                            0.621326                          0.769284  \n",
       "23                            0.629448                          0.779340  \n",
       "24                            0.636895                          0.788560  \n",
       "25                            0.643723                          0.797014  \n",
       "26                            0.649983                          0.804765  \n",
       "27                            0.655723                          0.811871  \n",
       "28                            0.660986                          0.818387  \n",
       "29                            0.665811                          0.824362  \n",
       "...                                ...                               ...  \n",
       "2129                          0.719040                          0.890266  \n",
       "2130                          0.719040                          0.890266  \n",
       "2131                          0.719040                          0.890266  \n",
       "2132                          0.719040                          0.890266  \n",
       "2133                          0.719040                          0.890266  \n",
       "2134                          0.719040                          0.890266  \n",
       "2135                          0.719040                          0.890266  \n",
       "2136                          0.719040                          0.890266  \n",
       "2137                          0.719040                          0.890266  \n",
       "2138                          0.719040                          0.890266  \n",
       "2139                          0.719040                          0.890266  \n",
       "2140                          0.719040                          0.890266  \n",
       "2141                          0.719040                          0.890266  \n",
       "2142                          0.719040                          0.890266  \n",
       "2143                          0.719040                          0.890266  \n",
       "2144                          0.719040                          0.890266  \n",
       "2145                          0.719040                          0.890266  \n",
       "2146                          0.719040                          0.890266  \n",
       "2147                          0.719040                          0.890266  \n",
       "2148                          0.719040                          0.890266  \n",
       "2149                          0.719040                          0.890266  \n",
       "2150                          0.719040                          0.890266  \n",
       "2151                          0.719040                          0.890266  \n",
       "2152                          0.719040                          0.890266  \n",
       "2153                          0.719040                          0.890266  \n",
       "2154                          0.719040                          0.890266  \n",
       "2155                          0.719040                          0.890266  \n",
       "2156                          0.719040                          0.890266  \n",
       "2157                          0.719040                          0.890266  \n",
       "2158                          0.719040                          0.890266  \n",
       "\n",
       "[2159 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filename = 'dfs0 FilePath'\n",
    "dfs0_obj = dfs0(filename)\n",
    "dfs0_obj.dfs0_read()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
